{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Лист1 "],"read":"whole","date_system":"1900"}

{"sheet":"Лист1 ","index":0,"n_rows":171,"n_cols":12,"rows_kept":171,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[20,2,20,3],[36,2,36,3],[53,2,53,3],[69,2,69,3],[85,2,85,3],[101,2,101,3],[118,2,118,3],[135,2,135,3],[152,2,152,3],[169,2,169,3],[170,2,170,4]]}
["Школа",null,"МБОУ \"Благодатновская СОШ\" НМР РТ",null,null,"Согласование:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Комарова Ш.Г."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",10,2,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","доп.гарнир","хлеб с сыром","30",4.15,2.82,9.84,81.33,null,83.89]
[{"$nulls":3},"гор.блюдо","Котлеты Домашние с гречкой","90",8.01,11.14,35.71,248]
[{"$nulls":3},"гарнир","Макаронные изделия (рожки) отварные с маслом сливочным","155",5.9,4.58,31.96,191.2]
[{"$nulls":3},"напиток","Чай без сахара","200",{"v":0.4,"d":"0.40"},{"v":0.1,"d":"0.10"},0.01,{"v":2.8,"d":"2.80"}]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.65,0.3,9.9,49.5]
[]
[{"$nulls":3},"итого",null,"500",{"$f":"SUM(G6:G11)","v":20.11},{"$f":"SUM(H6:H11)","v":18.94},87.42,572.8299999999999,null,{"$f":"SUM(L6:L11)","v":83.89}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F13:F19)","v":0},{"$f":"SUM(G13:G19)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H13:H19)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I13:I19)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J13:J19)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(L13:L19)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F12+F20","v":500},{"$f":"G12+G20","v":20.11},{"$f":"H12+H20","v":18.94},{"$f":"I12+I20","v":87.42},{"$f":"J12+J20","v":572.8299999999999},null,{"$f":"L12+L20","v":83.89}]
[1,2,"Завтрак","гор.блюдо","Биточки куриные Солнышко","90",6.01,11.53,12.88,183.45,null,83.89]
[{"$nulls":3},"гарнир","Каша пшеничная вязкая с маслом сливочным","153",{"v":6.7,"d":"6.70"},4.38,35.99,{"v":227,"d":"227.00"}]
[{"$nulls":3},"напиток","Кофейный напиток с молоком","200",3.17,2.68,9.98,{"v":60.1,"d":"60.10"}]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный ","30",2.28,0.24,{"v":14.759999999999998,"d":"14.76"},{"v":70.5,"d":"70.50"}]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[]
[{"$nulls":3},"итого",null,"503",{"$f":"SUM(G22:G27)","v":20.14},{"$f":"SUM(H22:H27)","v":{"v":19.189999999999998,"d":"19.19"}},{"$f":"SUM(I22:I27)","v":{"v":85.49000000000001,"d":"85.49"}},{"$f":"SUM(J22:J27)","v":{"v":600.4499999999999,"d":"600.45"}},null,{"$f":"SUM(L22:L27)","v":83.89}]
[{"$f":"A22","v":1},{"$f":"B22","v":2},"Обед"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F29:F35)","v":0},{"$f":"SUM(G29:G35)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H29:H35)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I29:I35)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J29:J35)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(L29:L35)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A22","v":1},{"$f":"B22","v":2},"Итого за день:",null,null,{"$f":"F28+F36","v":503},{"$f":"G28+G36","v":20.14},{"$f":"H28+H36","v":19.189999999999998},{"$f":"I28+I36","v":85.49000000000001},{"$f":"J28+J36","v":600.4499999999999},null,{"$f":"L28+L36","v":83.89}]
[1,3,"Завтрак","фрукты","Яблоко","100",0.4,0.4,9.8,47,null,83.89]
[{"$nulls":3},"гор.блюдо","Плов из куриной грудки","200",15.42,17.96,38.93,390.5]
[{"$nulls":3},"гор.напиток","Чай с сахаром и лимоном","200",0.13,0.02,8.2,34.02]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный","30",2.28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[{"$nulls":3},"итого",null,"550",{"$f":"SUM(G38:G43)","v":19.55},{"$f":"SUM(H38:H43)","v":18.859999999999996},{"$f":"SUM(I38:I43)","v":79.61000000000001},{"$f":"SUM(J38:J43)","v":581.62},null,{"$f":"SUM(L38:L43)","v":83.89}]
[{"$f":"A38","v":1},{"$f":"B38","v":3},"Обед"]
{"$rows_empty":7}
[{"$nulls":3},"итого",null,{"$f":"SUM(F45:F52)","v":0},{"$f":"SUM(G45:G52)","v":0},{"$f":"SUM(H45:H52)","v":0},{"$f":"SUM(I45:I52)","v":0},{"$f":"SUM(J45:J52)","v":0},null,{"$f":"SUM(L45:L52)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A38","v":1},{"$f":"B38","v":3},"Итого за день:",null,null,550,"19.55",18.86,79.61,39,null,83.89]
[1,4,"Завтрак","гор.блюдо","Овощи тушенные с мясом","200",14.05,15.97,32.8,374.45,null,83.89]
[{"$nulls":3},"доп.гарнир","Капуста квашенная","50",0.85,2.5,4.22,42.85]
[{"$nulls":3},"напиток","Напиток из урюка","200",0.75,0.06,15.95,68.52]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный","30",2.28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[{"$nulls":3},"итого",null,"510",{"$f":"SUM(G55:G60)","v":19.91},{"$f":"SUM(H55:H60)","v":19.129999999999995},{"$f":"SUM(I55:I60)","v":79.61},{"$f":"SUM(J55:J60)","v":615.7199999999999},null,{"$f":"L55","v":83.89}]
[{"$f":"A55","v":1},{"$f":"B55","v":4},"Обед"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F62:F68)","v":0},{"$f":"SUM(G62:G68)","v":0},{"$f":"SUM(H62:H68)","v":0},{"$f":"SUM(I62:I68)","v":0},{"$f":"SUM(J62:J68)","v":0},null,{"$f":"SUM(L62:L68)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A55","v":1},{"$f":"B55","v":4},"Итого за день:",null,null,{"$f":"F61+F69","v":510},{"$f":"G61+G69","v":19.91},19.129999999999995,79.61,615.7199999999999,null,{"$f":"L61+L69","v":83.89}]
[1,5,"Завтрак","фрукты","Яблоко","100",{"v":0.4,"d":"0.40"},{"v":0.4,"d":"0.40"},{"v":9.8,"d":"9.80"},{"v":47,"d":"47.00"},null,83.89]
[{"$nulls":3},"гор.блюдо","Сырники из творога со сгущенным молоком","150",15.55,18.35,36.03,398.93]
[{"$nulls":3},"гор.напиток","Чай с сахаром","200",0.07,0.02,{"v":8,"d":"8.00"},{"v":32,"d":"32.00"}]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный","30",{"v":2.2,"d":"2.20"},0.24,14.76,{"v":70.5,"d":"70.50"}]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[]
[{"$nulls":3},"итого",null,"510",{"$f":"SUM(G71:G76)","v":20.2},{"$f":"SUM(H71:H76)","v":19.369999999999997},{"$f":"SUM(I71:I76)","v":80.47},{"$f":"SUM(J71:J76)","v":607.83},null,{"$f":"SUM(L71:L76)","v":83.89}]
[{"$f":"A71","v":1},{"$f":"B71","v":5},"Обед"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F78:F84)","v":0},{"$f":"SUM(G78:G84)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H78:H84)","v":0},{"$f":"SUM(I78:I84)","v":0},{"$f":"SUM(J78:J84)","v":0},null,{"$f":"SUM(L78:L84)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A71","v":1},{"$f":"B71","v":5},"Итого за день:",null,null,{"$f":"F77+F85","v":510},{"$f":"G77+G85","v":20.2},{"$f":"H77+H85","v":19.369999999999997},{"$f":"I77+I85","v":80.47},{"$f":"J77+J85","v":607.83},null,{"$f":"L77+L85","v":83.89}]
[2,1,"Завтрак","хлеб бел.","Бутерброд с маслом сливочным","40",2.36,7.49,14.89,{"v":136,"d":"136.00"},null,83.89]
[{"$nulls":3},"гор.блюдо","Биточки рыбные","90",10.68,8.98,16.21,{"v":170.2,"d":"170.20"}]
[{"$nulls":3},"гарнир","Макаронные изделия (рожки) отварные с маслом сливочным","153",5.68,2.88,31.96,{"v":176.1,"d":"176.10"}]
[{"$nulls":3},"напиток","Чай с сахаром, с яблоком",200,0.11,0.06,8.97,36.68]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,{"v":39.6,"d":"39.60"}]
[{"$nulls":3},"итого",null,"500",{"$f":"SUM(G87:G91)","v":20.15},{"$f":"SUM(H87:H91)","v":{"v":19.649999999999995,"d":"19.65"}},{"$f":"SUM(I87:I91)","v":79.95},{"$f":"SUM(J87:J91)","v":{"v":558.5799999999999,"d":"558.58"}},null,{"$f":"SUM(L87:L91)","v":83.89}]
[{"$f":"A87","v":2},{"$f":"B87","v":1},"Обед"]
{"$rows_empty":7}
[{"$nulls":3},"итого",null,{"$f":"SUM(F93:F100)","v":0},{"$f":"SUM(G93:G100)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H93:H100)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I93:I100)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J93:J100)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(L93:L100)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A87","v":2},{"$f":"B87","v":1},"Итого за день:",null,null,{"$f":"F92+F101","v":500},{"$f":"G92+G101","v":20.15},{"$f":"H92+H101","v":19.649999999999995},{"$f":"I92+I101","v":79.95},{"$f":"J92+J101","v":558.5799999999999},null,{"$f":"L92+L101","v":83.89}]
[2,2,"Завтрак","фрукты","Яблоко","100",0.4,0.4,{"v":9.8,"d":"9.80"},{"v":47,"d":"47.00"},null,83.89]
[{"$nulls":3},"гор.блюдо","Жаркое из птицы (куринных грудок)","200",17.01,18.47,52.76,473.54]
[{"$nulls":3},"напиток","Чай с сахаром","200",0.07,0.02,{"v":8,"d":"8.00"},{"v":32,"d":"32.00"}]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной","30",1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F103+F104+F105+F106","v":530},{"$f":"SUM(G103:G108)","v":19.46},{"$f":"SUM(H103:H108)","v":19.249999999999996},{"$f":"SUM(I103:I108)","v":82.44},{"$f":"SUM(J103:J108)","v":{"v":611.9399999999999,"d":"611.94"}},null,{"$f":"L103","v":83.89}]
[{"$f":"A103","v":2},{"$f":"B103","v":2},"Обед"]
{"$rows_empty":7}
[{"$nulls":3},"итого",null,{"$f":"SUM(F110:F117)","v":0},{"$f":"SUM(G110:G117)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H110:H117)","v":0},{"$f":"SUM(I110:I117)","v":0},{"$f":"SUM(J110:J117)","v":0},null,{"$f":"SUM(L110:L117)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A103","v":2},{"$f":"B103","v":2},"Итого за день:",null,null,{"$f":"F109+F118","v":530},{"$f":"G109+G118","v":19.46},{"$f":"H109+H118","v":19.249999999999996},{"$f":"I109+I118","v":82.44},{"$f":"J109+J118","v":611.9399999999999},null,{"$f":"L109+L118","v":83.89}]
[2,3,"Завтрак","гор.блюдо","Котлеты Здоровье из куриных грудок","90",11.2,10.96,24.82,229.63,null,83.89]
[{"$nulls":3},"гарнир","Каша гречневая вязкая с маслом сливочным","153",4.6,7.19,20.56,165.3]
[{"$nulls":3},"напиток","Чай с сахаром и лимоном","200",0.13,0.02,8.2,34.02]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный","30",2.28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[{"$nulls":3},"итого",null,"503",{"$f":"SUM(G120:G125)","v":20.19},{"$f":"SUM(H120:H125)","v":18.77},{"$f":"SUM(I120:I125)","v":80.22},{"$f":"SUM(J120:J125)","v":558.85},null,{"$f":"L120","v":83.89}]
[{"$f":"A120","v":2},{"$f":"B120","v":3},"Обед",{"$nulls":8},83.89]
{"$rows_empty":7}
[{"$nulls":3},"итого",null,{"$f":"SUM(F127:F134)","v":0},{"$f":"SUM(G127:G134)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H127:H134)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I127:I134)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J127:J134)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A120","v":2},{"$f":"B120","v":3},"Итого за день:",null,null,{"$f":"F126+F135","v":503},{"$f":"G126+G135","v":20.19},{"$f":"H126+H135","v":18.77},{"$f":"I126+I135","v":80.22},{"$f":"J126+J135","v":558.85},null,{"$f":"L126+L135","v":83.89}]
[2,4,"Завтрак","сладкое","Крекер","30",2.7,5.4,14.2,135,null,83.89]
[{"$nulls":3},"гор.блюдо","Тефтели мясные с геркулесом","90",8.86,10.56,6.76,109.59]
[{"$nulls":3},"гарнир","Макаронные изделия (рожки отварные с маслом сливочным","153",5.68,2.88,31.96,176.1]
[{"$nulls":3},"напиток","Напиток из плодов шиповника","200",0.6,0.1,20.2,123.6]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[]
[{"$nulls":3},"итого",null,503,{"$f":"SUM(G137:G142)","v":20.12},{"$f":"SUM(H137:H142)","v":19.18},{"$f":"SUM(I137:I142)","v":87.88000000000001},{"$f":"SUM(J137:J142)","v":614.79},null,{"$f":"L137","v":83.89}]
[{"$f":"A137","v":2},{"$f":"B137","v":4},"Обед"]
{"$rows_empty":7}
[{"$nulls":3},"итого",null,{"$f":"SUM(F144:F151)","v":0},{"$f":"SUM(G144:G151)","v":0},{"$f":"SUM(H144:H151)","v":0},{"$f":"SUM(I144:I151)","v":0},{"$f":"SUM(J144:J151)","v":0},null,{"$f":"SUM(L144:L151)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A137","v":2},{"$f":"B137","v":4},"Итого за день:",null,null,{"$f":"F143+F152","v":503},{"$f":"G143+G152","v":20.12},{"$f":"H143+H152","v":19.18},{"$f":"I143+I152","v":87.88000000000001},{"$f":"J143+J152","v":614.79},null,{"$f":"L143+L152","v":83.89}]
[2,5,"Завтрак","фрукты","Яблоки","100",0.4,0.4,9.8,47,null,83.89]
[{"$nulls":3},"гор.блюдо","Гуляш из куриной грудки","100",8.64,9.83,13.4,209.39]
[{"$nulls":3},"доп гарнир","Пюре карофельное","150",3.09,4.98,39.48,177.55]
[{"$nulls":3},"напиток","Како с молоком","200",4.08,3.54,2.61,58.6]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[]
[{"$nulls":3},"итого",null,580,{"$f":"SUM(G154:G159)","v":18.490000000000002},{"$f":"SUM(H154:H159)","v":18.99},{"$f":"SUM(I154:I159)","v":80.05000000000001},{"$f":"SUM(J154:J159)","v":563.04},null,{"$f":"L154","v":83.89}]
[{"$f":"A154","v":2},{"$f":"B154","v":5},"Обед"]
{"$rows_empty":7}
[{"$nulls":3},"итого",null,{"$f":"SUM(F161:F168)","v":0},{"$f":"SUM(G161:G168)","v":0},{"$f":"SUM(H161:H168)","v":0},{"$f":"SUM(I161:I168)","v":0},{"$f":"SUM(J161:J168)","v":0},null,{"$f":"SUM(L161:L168)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A154","v":2},{"$f":"B154","v":5},"Итого за день:",null,null,{"$f":"F160+F169","v":580},{"$f":"G160+G169","v":18.490000000000002},{"$f":"H160+H169","v":18.99},{"$f":"I160+I169","v":80.05000000000001},{"$f":"J160+J169","v":563.04},null,{"$f":"L160+L169","v":83.89}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F21+F37+F54+F70+F86+F102+F119+F136+F153+F170)/(IF(F21=0,0,1)+IF(F37=0,0,1)+IF(F54=0,0,1)+IF(F70=0,0,1)+IF(F86=0,0,1)+IF(F102=0,0,1)+IF(F119=0,0,1)+IF(F136=0,0,1)+IF(F153=0,0,1)+IF(F170=0,0,1))","v":518.9},{"$f":"(G21+G37+G54+G70+G86+G102+G119+G136+G153+G170)/(IF(G21=0,0,1)+IF(G37=0,0,1)+IF(G54=0,0,1)+IF(G70=0,0,1)+IF(G86=0,0,1)+IF(G102=0,0,1)+IF(G119=0,0,1)+IF(G136=0,0,1)+IF(G153=0,0,1)+IF(G170=0,0,1))","v":{"$error":"#VALUE!"}},{"$f":"(H21+H37+H54+H70+H86+H102+H119+H136+H153+H170)/(IF(H21=0,0,1)+IF(H37=0,0,1)+IF(H54=0,0,1)+IF(H70=0,0,1)+IF(H86=0,0,1)+IF(H102=0,0,1)+IF(H119=0,0,1)+IF(H136=0,0,1)+IF(H153=0,0,1)+IF(H170=0,0,1))","v":{"v":19.133,"d":"19.13"}},{"$f":"(I21+I37+I54+I70+I86+I102+I119+I136+I153+I170)/(IF(I21=0,0,1)+IF(I37=0,0,1)+IF(I54=0,0,1)+IF(I70=0,0,1)+IF(I86=0,0,1)+IF(I102=0,0,1)+IF(I119=0,0,1)+IF(I136=0,0,1)+IF(I153=0,0,1)+IF(I170=0,0,1))","v":82.31400000000001},{"$f":"(J21+J37+J54+J70+J86+J102+J119+J136+J153+J170)/(IF(J21=0,0,1)+IF(J37=0,0,1)+IF(J54=0,0,1)+IF(J70=0,0,1)+IF(J86=0,0,1)+IF(J102=0,0,1)+IF(J119=0,0,1)+IF(J136=0,0,1)+IF(J153=0,0,1)+IF(J170=0,0,1))","v":534.303},null,{"$f":"(L21+L37+L54+L70+L86+L102+L119+L136+L153+L170)/(IF(L21=0,0,1)+IF(L37=0,0,1)+IF(L54=0,0,1)+IF(L70=0,0,1)+IF(L86=0,0,1)+IF(L102=0,0,1)+IF(L119=0,0,1)+IF(L136=0,0,1)+IF(L153=0,0,1)+IF(L170=0,0,1))","v":83.89}]